import pandas as pd

data = [
        {
            "device_name": "4F-北侧温湿度1",
            "humidityValue": "50.70 %",
            "temperatureValue": "19.40 ℃"
        },
        {
            "device_name": "4F-北侧温湿度2",
            "humidityValue": "50.30 %",
            "temperatureValue": "19.70 ℃"
        },
        {
            "device_name": "4F-北侧温湿度3",
            "humidityValue": "50.30 %",
            "temperatureValue": "19.60 ℃"
        },
        {
            "device_name": "4F-北侧温湿度4",
            "humidityValue": "52.00 %",
            "temperatureValue": "19.10 ℃"
        },
        {
            "device_name": "4F-北侧温湿度5",
            "humidityValue": "50.40 %",
            "temperatureValue": "19.60 ℃"
        },
        {
            "device_name": "4F-北侧温湿度6",
            "humidityValue": "45.80 %",
            "temperatureValue": "21.20 ℃"
        },
        {
            "device_name": "4F-北侧温湿度7",
            "humidityValue": "45.20 %",
            "temperatureValue": "21.60 ℃"
        },
        {
            "device_name": "4F-北侧温湿度8",
            "humidityValue": "46.80 %",
            "temperatureValue": "21.00 ℃"
        },
        {
            "device_name": "4F-北侧温湿度9",
            "humidityValue": "51.70 %",
            "temperatureValue": "19.30 ℃"
        },
        {
            "device_name": "4F-东侧温湿度1",
            "humidityValue": "44.50 %",
            "temperatureValue": "22.00 ℃"
        },
        {
            "device_name": "4F-东侧温湿度2",
            "humidityValue": "40.20 %",
            "temperatureValue": "23.30 ℃"
        },
        {
            "device_name": "4F-东侧温湿度3",
            "humidityValue": "40.10 %",
            "temperatureValue": "23.60 ℃"
        },
        {
            "device_name": "4F-东侧温湿度4",
            "humidityValue": "47.80 %",
            "temperatureValue": "20.60 ℃"
        },
        {
            "device_name": "4F-东侧温湿度5",
            "humidityValue": "46.10 %",
            "temperatureValue": "21.10 ℃"
        },
        {
            "device_name": "4F-东侧温湿度6",
            "humidityValue": "38.80 %",
            "temperatureValue": "24.00 ℃"
        },
        {
            "device_name": "4F-东侧温湿度7",
            "humidityValue": "33.50 %",
            "temperatureValue": "27.20 ℃"
        },
        {
            "device_name": "4F-东侧温湿度8",
            "humidityValue": "37.50 %",
            "temperatureValue": "26.20 ℃"
        },
        {
            "device_name": "4F-南侧温湿度1",
            "humidityValue": "47.00 %",
            "temperatureValue": "20.50 ℃"
        },
        {
            "device_name": "4F-南侧温湿度2",
            "humidityValue": "50.90 %",
            "temperatureValue": "19.40 ℃"
        },
        {
            "device_name": "4F-南侧温湿度3",
            "humidityValue": "51.40 %",
            "temperatureValue": "19.40 ℃"
        },
        {
            "device_name": "4F-南侧温湿度4",
            "humidityValue": "50.70 %",
            "temperatureValue": "19.50 ℃"
        },
        {
            "device_name": "4F-南侧温湿度5",
            "humidityValue": "48.90 %",
            "temperatureValue": "20.10 ℃"
        },
        {
            "device_name": "4F-南侧温湿度6",
            "humidityValue": "45.90 %",
            "temperatureValue": "21.10 ℃"
        },
        {
            "device_name": "4F-南侧温湿度7",
            "humidityValue": "44.40 %",
            "temperatureValue": "21.50 ℃"
        },
        {
            "device_name": "4F-南侧温湿度8",
            "humidityValue": "41.20 %",
            "temperatureValue": "22.80 ℃"
        },
        {
            "device_name": "4F-西通道温湿度1",
            "humidityValue": "50.30 %",
            "temperatureValue": "19.60 ℃"
        },
        {
            "device_name": "4F-西通道温湿度2",
            "humidityValue": "48.30 %",
            "temperatureValue": "20.40 ℃"
        },
        {
            "device_name": "4F-西通道温湿度3",
            "humidityValue": "47.00 %",
            "temperatureValue": "20.60 ℃"
        },
        {
            "device_name": "4F-西通道温湿度4",
            "humidityValue": "49.10 %",
            "temperatureValue": "20.10 ℃"
        },
        {
            "device_name": "4F-西通道温湿度5",
            "humidityValue": "45.90 %",
            "temperatureValue": "21.10 ℃"
        },
        {
            "device_name": "4F-西通道温湿度6",
            "humidityValue": "46.70 %",
            "temperatureValue": "20.90 ℃"
        },
        {
            "device_name": "4F-西通道温湿度7",
            "humidityValue": "46.10 %",
            "temperatureValue": "21.30 ℃"
        },
        {
            "device_name": "4F-西通道温湿度8",
            "humidityValue": "44.20 %",
            "temperatureValue": "21.80 ℃"
        },
        {
            "device_name": "5F-北侧温湿度1",
            "humidityValue": "75.40 %",
            "temperatureValue": "24.10 ℃"
        },
        {
            "device_name": "5F-北侧温湿度2",
            "humidityValue": "74.80 %",
            "temperatureValue": "23.80 ℃"
        },
        {
            "device_name": "5F-北侧温湿度3",
            "humidityValue": "72.40 %",
            "temperatureValue": "24.60 ℃"
        },
        {
            "device_name": "5F-北侧温湿度4",
            "humidityValue": "75.20 %",
            "temperatureValue": "23.50 ℃"
        },
        {
            "device_name": "5F-北侧温湿度5",
            "humidityValue": "72.10 %",
            "temperatureValue": "25.00 ℃"
        },
        {
            "device_name": "5F-北侧温湿度6",
            "humidityValue": "71.00 %",
            "temperatureValue": "24.90 ℃"
        },
        {
            "device_name": "5F-北侧温湿度7",
            "humidityValue": "75.40 %",
            "temperatureValue": "24.20 ℃"
        },
        {
            "device_name": "5F-北侧温湿度8",
            "humidityValue": "74.50 %",
            "temperatureValue": "25.00 ℃"
        },
        {
            "device_name": "5F-北侧温湿度9",
            "humidityValue": "72.50 %",
            "temperatureValue": "25.60 ℃"
        },
        {
            "device_name": "5F-东侧温湿度1",
            "humidityValue": "72.40 %",
            "temperatureValue": "25.90 ℃"
        },
        {
            "device_name": "5F-东侧温湿度2",
            "humidityValue": "68.50 %",
            "temperatureValue": "26.80 ℃"
        },
        {
            "device_name": "5F-东侧温湿度3",
            "humidityValue": "69.50 %",
            "temperatureValue": "26.80 ℃"
        },
        {
            "device_name": "5F-东侧温湿度4",
            "humidityValue": "71.50 %",
            "temperatureValue": "25.70 ℃"
        },
        {
            "device_name": "5F-东侧温湿度5",
            "humidityValue": "70.10 %",
            "temperatureValue": "26.60 ℃"
        },
        {
            "device_name": "5F-东侧温湿度6",
            "humidityValue": "70.10 %",
            "temperatureValue": "26.40 ℃"
        },
        {
            "device_name": "5F-东侧温湿度7",
            "humidityValue": "53.40 %",
            "temperatureValue": "31.20 ℃"
        },
        {
            "device_name": "5F-东侧温湿度8",
            "humidityValue": "61.00 %",
            "temperatureValue": "28.80 ℃"
        },
        {
            "device_name": "5F-南侧温湿度1",
            "humidityValue": "75.10 %",
            "temperatureValue": "24.10 ℃"
        },
        {
            "device_name": "5F-南侧温湿度2",
            "humidityValue": "76.00 %",
            "temperatureValue": "23.80 ℃"
        },
        {
            "device_name": "5F-南侧温湿度3",
            "humidityValue": "76.40 %",
            "temperatureValue": "23.50 ℃"
        },
        {
            "device_name": "5F-南侧温湿度4",
            "humidityValue": "77.70 %",
            "temperatureValue": "23.50 ℃"
        },
        {
            "device_name": "5F-南侧温湿度5",
            "humidityValue": "77.30 %",
            "temperatureValue": "23.80 ℃"
        },
        {
            "device_name": "5F-南侧温湿度6",
            "humidityValue": "76.00 %",
            "temperatureValue": "23.70 ℃"
        },
        {
            "device_name": "5F-南侧温湿度7",
            "humidityValue": "78.50 %",
            "temperatureValue": "23.50 ℃"
        },
        {
            "device_name": "5F-南侧温湿度8",
            "humidityValue": "72.60 %",
            "temperatureValue": "24.70 ℃"
        },
        {
            "device_name": "5F-西通道温湿度1",
            "humidityValue": "76.40 %",
            "temperatureValue": "23.90 ℃"
        },
        {
            "device_name": "5F-西通道温湿度2",
            "humidityValue": "76.10 %",
            "temperatureValue": "24.10 ℃"
        },
        {
            "device_name": "5F-西通道温湿度3",
            "humidityValue": "77.30 %",
            "temperatureValue": "24.00 ℃"
        },
        {
            "device_name": "5F-西通道温湿度4",
            "humidityValue": "77.20 %",
            "temperatureValue": "24.60 ℃"
        },
        {
            "device_name": "5F-西通道温湿度5",
            "humidityValue": "76.10 %",
            "temperatureValue": "24.50 ℃"
        },
        {
            "device_name": "5F-西通道温湿度6",
            "humidityValue": "75.80 %",
            "temperatureValue": "24.80 ℃"
        },
        {
            "device_name": "5F-西通道温湿度7",
            "humidityValue": "74.20 %",
            "temperatureValue": "24.90 ℃"
        },
        {
            "device_name": "5F-西通道温湿度8",
            "humidityValue": "73.70 %",
            "temperatureValue": "25.50 ℃"
        },
        {
            "device_name": "6F-北侧温湿度1",
            "humidityValue": "46.90 %",
            "temperatureValue": "20.70 ℃"
        },
        {
            "device_name": "6F-北侧温湿度2",
            "humidityValue": "47.70 %",
            "temperatureValue": "20.20 ℃"
        },
        {
            "device_name": "6F-北侧温湿度3",
            "humidityValue": "50.60 %",
            "temperatureValue": "19.20 ℃"
        },
        {
            "device_name": "6F-北侧温湿度4",
            "humidityValue": "49.60 %",
            "temperatureValue": "19.20 ℃"
        },
        {
            "device_name": "6F-北侧温湿度5",
            "humidityValue": "47.90 %",
            "temperatureValue": "20.10 ℃"
        },
        {
            "device_name": "6F-北侧温湿度6",
            "humidityValue": "50.00 %",
            "temperatureValue": "19.40 ℃"
        },
        {
            "device_name": "6F-北侧温湿度7",
            "humidityValue": "47.90 %",
            "temperatureValue": "20.00 ℃"
        },
        {
            "device_name": "6F-北侧温湿度8",
            "humidityValue": "44.70 %",
            "temperatureValue": "21.10 ℃"
        },
        {
            "device_name": "6F-东侧温湿度1",
            "humidityValue": "43.70 %",
            "temperatureValue": "22.20 ℃"
        },
        {
            "device_name": "6F-东侧温湿度2",
            "humidityValue": "43.50 %",
            "temperatureValue": "22.90 ℃"
        },
        {
            "device_name": "6F-东侧温湿度3",
            "humidityValue": "40.30 %",
            "temperatureValue": "23.80 ℃"
        },
        {
            "device_name": "6F-东侧温湿度4",
            "humidityValue": "45.20 %",
            "temperatureValue": "21.60 ℃"
        },
        {
            "device_name": "6F-东侧温湿度5",
            "humidityValue": "43.20 %",
            "temperatureValue": "22.70 ℃"
        },
        {
            "device_name": "6F-东侧温湿度6",
            "humidityValue": "41.60 %",
            "temperatureValue": "23.30 ℃"
        },
        {
            "device_name": "6F-东侧温湿度7",
            "humidityValue": "39.30 %",
            "temperatureValue": "24.80 ℃"
        },
        {
            "device_name": "6F-东侧温湿度8",
            "humidityValue": "37.60 %",
            "temperatureValue": "26.50 ℃"
        },
        {
            "device_name": "6F-南侧温湿度1",
            "humidityValue": "50.40 %",
            "temperatureValue": "19.10 ℃"
        },
        {
            "device_name": "6F-南侧温湿度2",
            "humidityValue": "50.10 %",
            "temperatureValue": "19.30 ℃"
        },
        {
            "device_name": "6F-南侧温湿度3",
            "humidityValue": "49.00 %",
            "temperatureValue": "19.80 ℃"
        },
        {
            "device_name": "6F-南侧温湿度4",
            "humidityValue": "51.00 %",
            "temperatureValue": "19.00 ℃"
        },
        {
            "device_name": "6F-南侧温湿度5",
            "humidityValue": "48.00 %",
            "temperatureValue": "19.90 ℃"
        },
        {
            "device_name": "6F-南侧温湿度6",
            "humidityValue": "50.90 %",
            "temperatureValue": "19.00 ℃"
        },
        {
            "device_name": "6F-南侧温湿度7",
            "humidityValue": "50.50 %",
            "temperatureValue": "19.30 ℃"
        },
        {
            "device_name": "6F-南侧温湿度8",
            "humidityValue": "47.60 %",
            "temperatureValue": "20.40 ℃"
        },
        {
            "device_name": "6F-西通道温湿度1",
            "humidityValue": "49.50 %",
            "temperatureValue": "19.70 ℃"
        },
        {
            "device_name": "6F-西通道温湿度2",
            "humidityValue": "48.20 %",
            "temperatureValue": "19.90 ℃"
        },
        {
            "device_name": "6F-西通道温湿度3",
            "humidityValue": "50.60 %",
            "temperatureValue": "19.60 ℃"
        },
        {
            "device_name": "6F-西通道温湿度4",
            "humidityValue": "48.20 %",
            "temperatureValue": "20.10 ℃"
        },
        {
            "device_name": "6F-西通道温湿度5",
            "humidityValue": "50.00 %",
            "temperatureValue": "19.80 ℃"
        },
        {
            "device_name": "6F-西通道温湿度6",
            "humidityValue": "46.60 %",
            "temperatureValue": "20.60 ℃"
        },
        {
            "device_name": "6F-西通道温湿度7",
            "humidityValue": "47.70 %",
            "temperatureValue": "20.80 ℃"
        },
        {
            "device_name": "6F-西通道温湿度8",
            "humidityValue": "44.80 %",
            "temperatureValue": "21.90 ℃"
        },
        {
            "device_name": "UPS间温湿度",
            "humidityValue": "60.10 %",
            "temperatureValue": "33.40 ℃"
        },
        {
            "device_name": "设备间温湿度",
            "humidityValue": "67.80 %",
            "temperatureValue": "31.30 ℃"
        },
        {
            "device_name": "通道温湿度1",
            "humidityValue": "54.50 %",
            "temperatureValue": "33.10 ℃"
        },
        {
            "device_name": "通道温湿度2",
            "humidityValue": "67.10 %",
            "temperatureValue": "28.20 ℃"
        },
        {
            "device_name": "通道温湿度3",
            "humidityValue": "72.80 %",
            "temperatureValue": "26.30 ℃"
        },
        {
            "device_name": "通道温湿度4",
            "humidityValue": "64.50 %",
            "temperatureValue": "28.30 ℃"
        },
        {
            "device_name": "通道温湿度5",
            "humidityValue": "61.80 %",
            "temperatureValue": "30.10 ℃"
        },
        {
            "device_name": "通道温湿度6",
            "humidityValue": "56.40 %",
            "temperatureValue": "32.40 ℃"
        }
    ]

df = pd.DataFrame(data)
df.to_excel('output.xlsx', index=False)